using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Configuration;
using Bussiness.Config;     
using Bussiness.Entity;
namespace Bussiness.ManagerBase
{
                

     public abstract class DMS009ManagerBase
    {
        public DMS009ManagerBase()
        {
            Adapter.ConnectionString =  ConnectionConfig.ConnectionString;            
        }
                    
 
        /// <summary>
        /// Them moi du lieu
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity Insert(DMS009Entity obj)
        { 
            return (DMS009Entity) Adapter.Insert(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo khoa chinh cua object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity Update(DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.Update(obj);             
        }
 
 
        public DMS009Entity Delete(DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.Delete(obj);             
        }
 


        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByACTFLG (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ACTFLG 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByACTFLG (string ACTFLG )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.ACTFLG = ACTFLG;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien COST duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByCOST (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"COST");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien COST 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByCOST (double COST )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.COST = COST;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"COST");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByCTDDTM (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDDTM 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByCTDDTM (DateTime CTDDTM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDDTM = CTDDTM;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByCTDPGM (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDPGM 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByCTDPGM (string CTDPGM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDPGM = CTDPGM;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByCTDUSR (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDUSR 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByCTDUSR (string CTDUSR )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDUSR = CTDUSR;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByCTDWKS (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDWKS 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByCTDWKS (string CTDWKS )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDWKS = CTDWKS;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByLSTMDF (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LSTMDF 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByLSTMDF (DateTime LSTMDF )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.LSTMDF = LSTMDF;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByMDFPGM (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFPGM 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByMDFPGM (string MDFPGM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFPGM = MDFPGM;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByMDFUSR (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFUSR 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByMDFUSR (string MDFUSR )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFUSR = MDFUSR;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByMDFWKS (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFWKS 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByMDFWKS (string MDFWKS )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFWKS = MDFWKS;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByPART_NO (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"PART_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PART_NO 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByPART_NO (string PART_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.PART_NO = PART_NO;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"PART_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByQTY (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien QTY 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByQTY (double QTY )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.QTY = QTY;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REC_ISS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREC_ISS_LINE_NO (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"REC_ISS_LINE_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REC_ISS_LINE_NO 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREC_ISS_LINE_NO (string REC_ISS_LINE_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REC_ISS_LINE_NO = REC_ISS_LINE_NO;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"REC_ISS_LINE_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REC_ISS_NO duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREC_ISS_NO (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"REC_ISS_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REC_ISS_NO 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREC_ISS_NO (string REC_ISS_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REC_ISS_NO = REC_ISS_NO;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"REC_ISS_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REF_NO1 duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREF_NO1 (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"REF_NO1");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REF_NO1 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREF_NO1 (string REF_NO1 )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO1 = REF_NO1;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"REF_NO1");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REF_NO2 duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREF_NO2 (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"REF_NO2");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REF_NO2 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREF_NO2 (string REF_NO2 )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO2 = REF_NO2;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"REF_NO2");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REF_NO3 duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREF_NO3 (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"REF_NO3");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REF_NO3 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREF_NO3 (string REF_NO3 )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO3 = REF_NO3;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"REF_NO3");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REF_TRS_NO duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREF_TRS_NO (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"REF_TRS_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REF_TRS_NO 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREF_TRS_NO (string REF_TRS_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_TRS_NO = REF_TRS_NO;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"REF_TRS_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REMAIN_QTY duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREMAIN_QTY (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"REMAIN_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien REMAIN_QTY 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByREMAIN_QTY (double REMAIN_QTY )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REMAIN_QTY = REMAIN_QTY;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"REMAIN_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_DAT duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_DAT (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_DAT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_DAT 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_DAT (string TRS_DAT )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_DAT = TRS_DAT;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_DAT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_LINE_NO (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_LINE_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_LINE_NO 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_LINE_NO (string TRS_LINE_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_LINE_NO = TRS_LINE_NO;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_LINE_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_NO duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_NO (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_NO 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_NO (string TRS_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_NO = TRS_NO;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_OPTR duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_OPTR (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_OPTR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_OPTR 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_OPTR (string TRS_OPTR )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_OPTR = TRS_OPTR;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_OPTR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_TIM duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_TIM (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_TIM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_TIM 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_TIM (string TRS_TIM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_TIM = TRS_TIM;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_TIM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_TOTAL duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_TOTAL (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_TOTAL");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TRS_TOTAL 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTRS_TOTAL (double TRS_TOTAL )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_TOTAL = TRS_TOTAL;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"TRS_TOTAL");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TYPE duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTYPE (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"TYPE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TYPE 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByTYPE (string TYPE )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TYPE = TYPE;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"TYPE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByWH_CODE (DMS009Entity obj)
        { 
            return (DMS009Entity)Adapter.DeleteByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien WH_CODE 
        /// </summary>
        /// <returns>DMS009Entity</returns>
        public DMS009Entity DeleteByWH_CODE (string WH_CODE )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.WH_CODE = WH_CODE;  
            return (DMS009Entity)Adapter.DeleteByField(obj,"WH_CODE");
        }

 
        /// <summary>
        /// Lay du lieu theo khoa chinh object
        /// </summary>
        /// <returns></returns>
        public DMS009Entity Select(DMS009Entity obj)
        { 
            return (DMS009Entity) Adapter.Select(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(DMS009Entity obj)
        { 
            return  Adapter.SelectWithCondition(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(DMS009Entity obj,SelectOptions option)
        {             
            return  Adapter.SelectWithCondition(obj,option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        { 
            return Adapter.SelectAll(new DMS009Entity());             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll(SelectOptions option)
        { 
            return Adapter.SelectAll(new DMS009Entity(),option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<DMS009Entity> SelectAllLST()
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new DMS009Entity()),new DMS009Entity());           
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<DMS009Entity> SelectAllLST(SelectOptions option)
        { 
            return (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new DMS009Entity(),option),new DMS009Entity());             
        }
 

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ACTFLG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByACTFLGLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByACTFLGLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ACTFLG",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (string ACTFLG )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.ACTFLG = ACTFLG;  
            return Adapter.SelectByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (string ACTFLG, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.ACTFLG = ACTFLG;  
            return Adapter.SelectByField(obj,"ACTFLG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByACTFLGLST (string ACTFLG )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.ACTFLG = ACTFLG;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByACTFLGLST (string ACTFLG, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.ACTFLG = ACTFLG;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COST duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCOST (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"COST");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COST duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCOST (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"COST",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COST duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByCOSTLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"COST"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COST duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByCOSTLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"COST",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COST 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCOST (double COST )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.COST = COST;  
            return Adapter.SelectByField(obj,"COST");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COST duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCOST (double COST, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.COST = COST;  
            return Adapter.SelectByField(obj,"COST",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COST 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByCOSTLST (double COST )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.COST = COST;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"COST"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COST duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByCOSTLST (double COST, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.COST = COST;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"COST",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDDTM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByCTDDTMLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByCTDDTMLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDDTM",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DateTime CTDDTM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDDTM = CTDDTM;  
            return Adapter.SelectByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DateTime CTDDTM, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDDTM = CTDDTM;  
            return Adapter.SelectByField(obj,"CTDDTM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByCTDDTMLST (DateTime CTDDTM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDDTM = CTDDTM;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByCTDDTMLST (DateTime CTDDTM, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDDTM = CTDDTM;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByCTDPGMLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByCTDPGMLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDPGM",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (string CTDPGM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDPGM = CTDPGM;  
            return Adapter.SelectByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (string CTDPGM, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDPGM = CTDPGM;  
            return Adapter.SelectByField(obj,"CTDPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByCTDPGMLST (string CTDPGM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDPGM = CTDPGM;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByCTDPGMLST (string CTDPGM, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDPGM = CTDPGM;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByCTDUSRLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByCTDUSRLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDUSR",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (string CTDUSR )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDUSR = CTDUSR;  
            return Adapter.SelectByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (string CTDUSR, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDUSR = CTDUSR;  
            return Adapter.SelectByField(obj,"CTDUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByCTDUSRLST (string CTDUSR )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDUSR = CTDUSR;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByCTDUSRLST (string CTDUSR, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDUSR = CTDUSR;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByCTDWKSLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByCTDWKSLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDWKS",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (string CTDWKS )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDWKS = CTDWKS;  
            return Adapter.SelectByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (string CTDWKS, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDWKS = CTDWKS;  
            return Adapter.SelectByField(obj,"CTDWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByCTDWKSLST (string CTDWKS )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDWKS = CTDWKS;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByCTDWKSLST (string CTDWKS, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.CTDWKS = CTDWKS;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"LSTMDF",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByLSTMDFLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByLSTMDFLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"LSTMDF",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DateTime LSTMDF )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.LSTMDF = LSTMDF;  
            return Adapter.SelectByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DateTime LSTMDF, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.LSTMDF = LSTMDF;  
            return Adapter.SelectByField(obj,"LSTMDF",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByLSTMDFLST (DateTime LSTMDF )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.LSTMDF = LSTMDF;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByLSTMDFLST (DateTime LSTMDF, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.LSTMDF = LSTMDF;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByMDFPGMLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByMDFPGMLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFPGM",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (string MDFPGM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFPGM = MDFPGM;  
            return Adapter.SelectByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (string MDFPGM, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFPGM = MDFPGM;  
            return Adapter.SelectByField(obj,"MDFPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByMDFPGMLST (string MDFPGM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFPGM = MDFPGM;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByMDFPGMLST (string MDFPGM, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFPGM = MDFPGM;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByMDFUSRLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByMDFUSRLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFUSR",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (string MDFUSR )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFUSR = MDFUSR;  
            return Adapter.SelectByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (string MDFUSR, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFUSR = MDFUSR;  
            return Adapter.SelectByField(obj,"MDFUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByMDFUSRLST (string MDFUSR )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFUSR = MDFUSR;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByMDFUSRLST (string MDFUSR, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFUSR = MDFUSR;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByMDFWKSLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByMDFWKSLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFWKS",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (string MDFWKS )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFWKS = MDFWKS;  
            return Adapter.SelectByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (string MDFWKS, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFWKS = MDFWKS;  
            return Adapter.SelectByField(obj,"MDFWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByMDFWKSLST (string MDFWKS )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFWKS = MDFWKS;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByMDFWKSLST (string MDFWKS, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.MDFWKS = MDFWKS;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"PART_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"PART_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByPART_NOLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByPART_NOLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"PART_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (string PART_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.PART_NO = PART_NO;  
            return Adapter.SelectByField(obj,"PART_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (string PART_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.PART_NO = PART_NO;  
            return Adapter.SelectByField(obj,"PART_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByPART_NOLST (string PART_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.PART_NO = PART_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByPART_NOLST (string PART_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.PART_NO = PART_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByQTYLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByQTYLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"QTY",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (double QTY )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.QTY = QTY;  
            return Adapter.SelectByField(obj,"QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (double QTY, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.QTY = QTY;  
            return Adapter.SelectByField(obj,"QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByQTYLST (double QTY )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.QTY = QTY;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByQTYLST (double QTY, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.QTY = QTY;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREC_ISS_LINE_NO (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"REC_ISS_LINE_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREC_ISS_LINE_NO (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"REC_ISS_LINE_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREC_ISS_LINE_NOLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REC_ISS_LINE_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREC_ISS_LINE_NOLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"REC_ISS_LINE_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_LINE_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREC_ISS_LINE_NO (string REC_ISS_LINE_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REC_ISS_LINE_NO = REC_ISS_LINE_NO;  
            return Adapter.SelectByField(obj,"REC_ISS_LINE_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREC_ISS_LINE_NO (string REC_ISS_LINE_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REC_ISS_LINE_NO = REC_ISS_LINE_NO;  
            return Adapter.SelectByField(obj,"REC_ISS_LINE_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_LINE_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREC_ISS_LINE_NOLST (string REC_ISS_LINE_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REC_ISS_LINE_NO = REC_ISS_LINE_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REC_ISS_LINE_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREC_ISS_LINE_NOLST (string REC_ISS_LINE_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REC_ISS_LINE_NO = REC_ISS_LINE_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REC_ISS_LINE_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREC_ISS_NO (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"REC_ISS_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREC_ISS_NO (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"REC_ISS_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREC_ISS_NOLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REC_ISS_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREC_ISS_NOLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"REC_ISS_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREC_ISS_NO (string REC_ISS_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REC_ISS_NO = REC_ISS_NO;  
            return Adapter.SelectByField(obj,"REC_ISS_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREC_ISS_NO (string REC_ISS_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REC_ISS_NO = REC_ISS_NO;  
            return Adapter.SelectByField(obj,"REC_ISS_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREC_ISS_NOLST (string REC_ISS_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REC_ISS_NO = REC_ISS_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REC_ISS_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REC_ISS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREC_ISS_NOLST (string REC_ISS_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REC_ISS_NO = REC_ISS_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REC_ISS_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO1 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO1 (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"REF_NO1");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO1 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO1 (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"REF_NO1",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO1 duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREF_NO1LST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_NO1"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO1 duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREF_NO1LST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"REF_NO1",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO1 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO1 (string REF_NO1 )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO1 = REF_NO1;  
            return Adapter.SelectByField(obj,"REF_NO1");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO1 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO1 (string REF_NO1, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO1 = REF_NO1;  
            return Adapter.SelectByField(obj,"REF_NO1",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO1 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREF_NO1LST (string REF_NO1 )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO1 = REF_NO1;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_NO1"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO1 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREF_NO1LST (string REF_NO1, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO1 = REF_NO1;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_NO1",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO2 (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"REF_NO2");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO2 (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"REF_NO2",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO2 duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREF_NO2LST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_NO2"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO2 duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREF_NO2LST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"REF_NO2",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO2 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO2 (string REF_NO2 )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO2 = REF_NO2;  
            return Adapter.SelectByField(obj,"REF_NO2");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO2 (string REF_NO2, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO2 = REF_NO2;  
            return Adapter.SelectByField(obj,"REF_NO2",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO2 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREF_NO2LST (string REF_NO2 )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO2 = REF_NO2;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_NO2"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREF_NO2LST (string REF_NO2, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO2 = REF_NO2;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_NO2",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO3 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO3 (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"REF_NO3");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO3 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO3 (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"REF_NO3",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO3 duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREF_NO3LST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_NO3"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO3 duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREF_NO3LST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"REF_NO3",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO3 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO3 (string REF_NO3 )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO3 = REF_NO3;  
            return Adapter.SelectByField(obj,"REF_NO3");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO3 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_NO3 (string REF_NO3, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO3 = REF_NO3;  
            return Adapter.SelectByField(obj,"REF_NO3",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO3 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREF_NO3LST (string REF_NO3 )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO3 = REF_NO3;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_NO3"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_NO3 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREF_NO3LST (string REF_NO3, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_NO3 = REF_NO3;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_NO3",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_TRS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_TRS_NO (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"REF_TRS_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_TRS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_TRS_NO (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"REF_TRS_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_TRS_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREF_TRS_NOLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_TRS_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_TRS_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREF_TRS_NOLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"REF_TRS_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_TRS_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_TRS_NO (string REF_TRS_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_TRS_NO = REF_TRS_NO;  
            return Adapter.SelectByField(obj,"REF_TRS_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_TRS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREF_TRS_NO (string REF_TRS_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_TRS_NO = REF_TRS_NO;  
            return Adapter.SelectByField(obj,"REF_TRS_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_TRS_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREF_TRS_NOLST (string REF_TRS_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_TRS_NO = REF_TRS_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_TRS_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REF_TRS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREF_TRS_NOLST (string REF_TRS_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REF_TRS_NO = REF_TRS_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REF_TRS_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REMAIN_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREMAIN_QTY (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"REMAIN_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REMAIN_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREMAIN_QTY (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"REMAIN_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REMAIN_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREMAIN_QTYLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REMAIN_QTY"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REMAIN_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByREMAIN_QTYLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"REMAIN_QTY",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REMAIN_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREMAIN_QTY (double REMAIN_QTY )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REMAIN_QTY = REMAIN_QTY;  
            return Adapter.SelectByField(obj,"REMAIN_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REMAIN_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByREMAIN_QTY (double REMAIN_QTY, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REMAIN_QTY = REMAIN_QTY;  
            return Adapter.SelectByField(obj,"REMAIN_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REMAIN_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREMAIN_QTYLST (double REMAIN_QTY )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REMAIN_QTY = REMAIN_QTY;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REMAIN_QTY"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien REMAIN_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByREMAIN_QTYLST (double REMAIN_QTY, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.REMAIN_QTY = REMAIN_QTY;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"REMAIN_QTY",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_DAT (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"TRS_DAT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_DAT (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TRS_DAT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_DAT duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_DATLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_DAT"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_DAT duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_DATLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TRS_DAT",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_DAT 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_DAT (string TRS_DAT )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_DAT = TRS_DAT;  
            return Adapter.SelectByField(obj,"TRS_DAT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_DAT (string TRS_DAT, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_DAT = TRS_DAT;  
            return Adapter.SelectByField(obj,"TRS_DAT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_DAT 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_DATLST (string TRS_DAT )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_DAT = TRS_DAT;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_DAT"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_DATLST (string TRS_DAT, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_DAT = TRS_DAT;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_DAT",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_LINE_NO (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"TRS_LINE_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_LINE_NO (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TRS_LINE_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_LINE_NOLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_LINE_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_LINE_NOLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TRS_LINE_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_LINE_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_LINE_NO (string TRS_LINE_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_LINE_NO = TRS_LINE_NO;  
            return Adapter.SelectByField(obj,"TRS_LINE_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_LINE_NO (string TRS_LINE_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_LINE_NO = TRS_LINE_NO;  
            return Adapter.SelectByField(obj,"TRS_LINE_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_LINE_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_LINE_NOLST (string TRS_LINE_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_LINE_NO = TRS_LINE_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_LINE_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_LINE_NOLST (string TRS_LINE_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_LINE_NO = TRS_LINE_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_LINE_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_NO (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"TRS_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_NO (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TRS_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_NOLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_NOLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TRS_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_NO (string TRS_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_NO = TRS_NO;  
            return Adapter.SelectByField(obj,"TRS_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_NO (string TRS_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_NO = TRS_NO;  
            return Adapter.SelectByField(obj,"TRS_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_NOLST (string TRS_NO )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_NO = TRS_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_NO"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_NOLST (string TRS_NO, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_NO = TRS_NO;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_NO",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_OPTR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_OPTR (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"TRS_OPTR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_OPTR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_OPTR (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TRS_OPTR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_OPTR duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_OPTRLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_OPTR"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_OPTR duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_OPTRLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TRS_OPTR",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_OPTR 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_OPTR (string TRS_OPTR )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_OPTR = TRS_OPTR;  
            return Adapter.SelectByField(obj,"TRS_OPTR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_OPTR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_OPTR (string TRS_OPTR, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_OPTR = TRS_OPTR;  
            return Adapter.SelectByField(obj,"TRS_OPTR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_OPTR 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_OPTRLST (string TRS_OPTR )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_OPTR = TRS_OPTR;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_OPTR"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_OPTR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_OPTRLST (string TRS_OPTR, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_OPTR = TRS_OPTR;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_OPTR",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TIM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_TIM (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"TRS_TIM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TIM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_TIM (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TRS_TIM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TIM duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_TIMLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_TIM"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TIM duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_TIMLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TRS_TIM",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TIM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_TIM (string TRS_TIM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_TIM = TRS_TIM;  
            return Adapter.SelectByField(obj,"TRS_TIM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TIM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_TIM (string TRS_TIM, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_TIM = TRS_TIM;  
            return Adapter.SelectByField(obj,"TRS_TIM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TIM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_TIMLST (string TRS_TIM )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_TIM = TRS_TIM;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_TIM"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TIM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_TIMLST (string TRS_TIM, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_TIM = TRS_TIM;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_TIM",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_TOTAL (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"TRS_TOTAL");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_TOTAL (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TRS_TOTAL",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TOTAL duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_TOTALLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_TOTAL"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TOTAL duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTRS_TOTALLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TRS_TOTAL",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TOTAL 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_TOTAL (double TRS_TOTAL )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_TOTAL = TRS_TOTAL;  
            return Adapter.SelectByField(obj,"TRS_TOTAL");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTRS_TOTAL (double TRS_TOTAL, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_TOTAL = TRS_TOTAL;  
            return Adapter.SelectByField(obj,"TRS_TOTAL",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TOTAL 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_TOTALLST (double TRS_TOTAL )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_TOTAL = TRS_TOTAL;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_TOTAL"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TRS_TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTRS_TOTALLST (double TRS_TOTAL, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TRS_TOTAL = TRS_TOTAL;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TRS_TOTAL",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTYPE (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"TYPE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTYPE (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TYPE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTYPELST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TYPE"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByTYPELST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TYPE",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTYPE (string TYPE )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TYPE = TYPE;  
            return Adapter.SelectByField(obj,"TYPE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTYPE (string TYPE, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TYPE = TYPE;  
            return Adapter.SelectByField(obj,"TYPE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTYPELST (string TYPE )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TYPE = TYPE;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TYPE"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByTYPELST (string TYPE, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.TYPE = TYPE;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TYPE",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (DMS009Entity obj)
        { 
            return Adapter.SelectByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (DMS009Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"WH_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByWH_CODELST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectByWH_CODELST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"WH_CODE",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (string WH_CODE )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.WH_CODE = WH_CODE;  
            return Adapter.SelectByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (string WH_CODE, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.WH_CODE = WH_CODE;  
            return Adapter.SelectByField(obj,"WH_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByWH_CODELST (string WH_CODE )
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.WH_CODE = WH_CODE;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE"),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS009Entity> SelectByWH_CODELST (string WH_CODE, SelectOptions option)
        { 
            DMS009Entity obj = new DMS009Entity();
            obj.WH_CODE = WH_CODE;  
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE",option),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectWithConditionLST (DMS009Entity obj)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj),new DMS009Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<DMS009Entity></returns>
        public List<DMS009Entity> SelectWithConditionLST (DMS009Entity obj,SelectOptions option)
        { 
            return  (List<DMS009Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj,option),new DMS009Entity());
        }

}
}
